forum

home / developersection / forums / how to use pivot in sql query.

Ask Question

How To Use Pivot In SQL Query.

Anonymous User 1614 29-Oct-2015

Can anyone please help me how to solve this problem.

sql server

Updated on 29-Oct-2015

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

Answer

1 Answers

Anonymous User

29-Oct-2015

lets Step one create order table

create table [Order]
(
 OrderID int primary key identity(1,1),
 Orderdate datetime,
 amount decimal(10,2)
)
now select sample query from order table
 
SELECT year(Orderdate) as [year], left(datename(month,Orderdate),3)as [month], 
amount as Amount FROM [Order] as InvoiceResult

Now write pivot Query .

SELECT *
FROM (
    SELECT
        year(Orderdate) as [year],left(datename(month,Orderdate),3)as [month], 
        amount as Amount 
    FROM [Order]
) as s
PIVOT
(
    SUM(Amount)
    FOR [month] IN (jan, feb, mar, apr,
    may, jun, jul, aug, sep, oct, nov, dec)
)AS Result

forum

How To Use Pivot In SQL Query.

Anonymous User

Can you answer this question?

1 Answers

Liked By